﻿IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[esf_files].[P_DeleteAllFileReferenceWordHit.sql]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [esf_files].P_DeleteAllFileReferenceWordHit
GO


CREATE PROCEDURE esf_files.P_DeleteAllFileReferenceWordHit
	@pFileReferenceID INT
AS
	DELETE FROM esf_files.FileReferenceWordHit WHERE FileReferenceID = @pFileReferenceID